How to: Display a saved view.
Solution:
Select 'View Manager' from the 'View ' menu, select the name of the desired view, and click 'Show'.
1) Select the 'View' menu and select 'View Manager'.
NOTE: If 'View Manager' is not on the 'View' menu, load the 'View Manager' add-in in Microsoft Excel.
2) In the 'Views' group, select the name of the desired view.
3) Click 'Show'.